Human Resources Analytics: Exploring Employee Data in SQL
Welcome to my personal site yangyangjia.
Abstract
Businesses are increasingly counting on their human resource departments to answer employee engagement related questions. While, employee engagement has emerged as a critical driver of business success today. Engagement has significantly affect employee retention, productivity and loyalty. The research is based on the primary data developed by Patrick Crews and Giuseppe Maxia, provided a combination of a large base of data (approximately 160MB) spread over six separate tables and consisting of 4 million records in total. This study used SQL analysis and attempt to examine the level of employee engagement questions, such as the breakdown between male and female employees, managers, and the average salaries among different departments.
Visualization reports generated by Tableau
Check my SQL code
